FO_IF_Translations

This table is used to specify translation values for external data arriving through the Client Data Concentrator interfaces (CDC). [Being expanded to also include TDC]

Each record represents a particular field type of foreign and native values for an MPI qualifier and an Interface code. An interface code is assigned in the config file of the comms and processor jobs of an interface.

The combination of MPI Qualifier, Interface Code and Translation Type determines which definition is right to translate.

 

Field Type Notes

FO_IF_Translations_ID

int

ID field, a counter. Unique

InterfaceCode

varchar(50)

Interface code for this translation. The interface code is defined in the Comms and Processor jobs config files.

TranslationType

varchar(50)

Enter a single character that represents a translation type.

Allowed values:

I = insurance P = provider
C = client B = bill to
T = test code L = patient location
G = gender R = relationship value
S = species PR = priority
M = marital  

ForeignValue

varchar(50)

Enter a value for this translation type in the external system.

FPValue

varchar(50)

Enter a value to translate to in FAST.

For type I insurance translations, if the FPValue is "*DNU*", then the system will not record any insurances from that message.

The system will still record a value for Bill To, it will not be left blank.

This is only honored for the primary insurance (first IN1) segment in a message.

MPIQualifier

varchar(50)

MPI qualifier code.

Enter a valid MPI qualifier code.

CreateDate

datetime

Date record was created. Informational

CreatedBy

varchar(50)

User who created the record. Informational

EditDate

datetime

Date record was edited. Informational

EditedBy

varchar(50)

User who last edited the record. Informational

ForceBillTo

varchar(50)

Defines the billto value for every order created by reference to this translation.

Enter a valid FAST billto value. See Bill To table for valid entries of long code. [Insert link target_blank to Bill To table in the doc]

Only applies to translation type I insurance for the first IN1 segment.

This will override what was sent in the message or a default value for this MPI qualifier.

This logic will be used only if the translation rules are activated to cause the system to translate the insurance code in the message.

An IN1 segment must have at least an insurance code and a policy number to qualify as a valid segment. If it does not, no translation will be applied.

ClientCode

varchar(50)

Client code.

Enter a valid client code.

>>>> NEED More Definition <<<<